[dbo].[asi_PrcQueryPriceSheetVersion]

SQLServer > iMIS1521GA > Stored Procedures > dbo.asi_PrcQueryPriceSheetVersion

Property	Value
ANSI Nulls On
Quoted Identifier On

Name	Data Type	Max Length (Bytes)
@priceSheetKey	uniqueidentifier	16
@date	datetime	8

/* Look for a PriceSheetVersion, given a PriceSheet key and a date */

CREATE PROCEDURE [dbo].[asi_PrcQueryPriceSheetVersion]
    @priceSheetKey uniqueidentifier,
    @date datetime
    AS
BEGIN
    SELECT PriceSheetVersion.*
    FROM PriceSheetVersion
    WHERE PriceSheetKey=@priceSheetKey
    AND (BeginDate IS NULL OR BeginDate <= @date)
    AND (@date <= EndDate OR EndDate IS NULL)
END

GO